Using Aged Payables Report

1. When you first enter into the Aged Accounts Payable option, a Select An Option window appears with the following options:

• EXIT – Select EXIT to exit the Aged Payables Report and return to the Payables menu.
• ALL VENDORS – Select ALL VENDORS to generate the report for all vendors.
• SINGLE VENDOR – Select SINGLE VENDOR to generate the report for a single vendor.
• BY AP ACCOUNT – Select BY AP ACCOUNT to generate the report by an A/P account.

Scroll to the appropriate selection and press Enter to confirm your selection.

If you select a single vendor, enter in the appropriate six-character vendor ID code.

If you are uncertain of the Vendor code, see Navigating Net Yield - Selecting a Vendor Code.

If you select an accounts payable (AP) account a Select An Account window will appear displaying all accounts payable (AP) accounts assigned to the vendor(s). Scroll to the appropriate account and press Enter to confirm your selection.

Make your selection.

2. At the Aged as of field, enter the aged of date – the report will age the open accounts payable (AP) transactions as of this date. Press Enter to accept the current system default date.

Note: Changing the date to a prior date will only age the current balances as of the date entered. It will not recreate the report as for this date. To re-print a report for a prior date, the report must be printed from the Print End of Day option and selecting the aged payables report from the appropriate End of Day folder.

3. At the (S)ummary or (D)etail field, enter S (S=summary) to print the report with vendor (if you are running the report for one or more vendors) or accounts payable (if you are running the report for an accounts payable account) totals by aging column only. If you select D (D=detail), the system will generate a report in detail format. The open transactions include all open vouchers, purchase orders, voucher adjustments or advances for the customer.

4. A Select An Option window will appear:

• Received Date – Select Received Date to age payables based on the date received or voucher date.
• Past Terms – Select Past Terms to age payables based on the days past terms.
• Until Terms – Select Until Terms to age payables based on the days left until terms.

5. The aging columns allow you to set up the aging periods on the report. At the Aging Columns 1-4 fields, enter in the appropriate XX days or press Enter through each field to accept the system default defined in Payables Options.

• Aging Column 1 – The number of days in the first aging column
• Aging Column 2 – The number of days in the second aging column
• Aging Column 3 – The number of days in the third aging column
• Aging Column 4 – The number of days in the fourth aging column
• Aging Column 5 – Automatically displays amount beyond the fourth aging range.

6. The message line displays “Continue with report? No/Yes."

• Select no to leave this option.
• Select yes and command options will appear allowing you to print or choose from a set of other print options.

Use the Available Actions link below for more information.

Security Required : Payables - Payable Reports